/* For security reasons the login is created disabled and with a random password. */
CREATE LOGIN [nodeadmin] WITH PASSWORD=N'E$0', DEFAULT_DATABASE=[WADE], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=ON
GO
ALTER LOGIN [nodeadmin] DISABLE
GO
CREATE LOGIN [sara] WITH PASSWORD=N'?fs-', DEFAULT_DATABASE=[WADE], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
ALTER LOGIN [sara] DISABLE
GO
CREATE LOGIN [wade] WITH PASSWORD=N'p?L;bz?2#l1$(؝j??', DEFAULT_DATABASE=[WADE], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
EXEC sys.sp_addsrvrolemember @loginame = N'wade', @rolename = N'dbcreator'
GO
ALTER LOGIN [wade] DISABLE
GO
CREATE LOGIN [wade_app1] WITH PASSWORD=N'	-', DEFAULT_DATABASE=[WADE], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=ON
GO
ALTER LOGIN [wade_app1] DISABLE
GO
